from applications.extensions import db
import datetime
# 罪犯信息
class CriminalInformaModels(db.Model):

    __tablename__ = 'admin_criminal_information'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True, comment='识别标记')
    criminal_id = db.Column(db.String(20), comment='罪犯编号')
    name = db.Column(db.String(20), comment='罪犯姓名')
    sex = db.Column(db.String(20), comment='罪犯性别')
    native_place = db.Column(db.String(20), comment='罪犯籍贯')
    charge = db.Column(db.String(20), comment='罪名')
    subordi_jur = db.Column(db.String(20), comment='所属监区')
    control_type = db.Column(db.String(20), comment='严管类型')
    UWB_SN = db.Column(db.String(20), comment='UWB')
    GPS_SN = db.Column(db.String(20), comment='GPS')
    identify = db.Column(db.String(20), comment='身份证号')
    adress = db.Column(db.String(20), comment='住址')
    birth_date = db.Column(db.DateTime, comment='出生日期')
    create_time = db.Column(db.DateTime,default=datetime.datetime.now,comment='创建时间')
